package Gestores.DaoInterfaces;

import java.sql.Date;
import java.util.ArrayList;

public interface AfiliadoDAO extends BaseDAO {

    public ArrayList<Object> buscarPorId(String id) throws Exception;
    
    public ArrayList<Object> buscarPorCi(int ci) throws Exception;

    public ArrayList<Object> buscarPorNombres(String nombre) throws Exception;

    public ArrayList<Object> buscarPorApellidoPaterno(String apellidoPaterno) throws Exception;

    public ArrayList<Object> buscarPorApellidoMaterno(String apellidoMaterno) throws Exception;

    public ArrayList<Object> buscarPorEstadoCivil(char estadoCivil) throws Exception;

    public ArrayList<Object> buscarPorFechaInscripcion(Date fechaInscripcion) throws Exception;

    public ArrayList<Object> buscarPorActivos() throws Exception;

    public ArrayList<Object> buscarPorNoActivos() throws Exception;

    public boolean existe(String id) throws Exception;
}
